﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true" CodeFile="SV_StatEmp.aspx.cs" Inherits="ServicesSheet_SV_StatEmp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Titile" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" Runat="Server">
 <InfoLight:WebDataSource ID="Master" runat="server" AutoApply="True" WebDataSetID="WMaster" AllowAdd="True" AllowDelete="True" AllowPrint="True" AllowUpdate="True" AlwaysClose="False" AutoApplyForInsert="False" AutoRecordLock="False" AutoRecordLockMode="NoneReload" CacheDataSet="False" CommandName="" CommandText="" DataMember="SV_StatEmp" Eof="True" KeyValues="" LastIndex="-1" Marker="'" MasterDataSource="" PacketRecords="100" QuotePrefix="[" QuoteSuffix="]" RemoteName="" SelectCommand="" TableName="">
        </InfoLight:WebDataSource>
         <InfoLight:WebDataSource ID="wdsServices_SV_StatEmpEmployeeId" runat="server" SelectAlias="Usasdb" SelectCommand="SELECT Employees.EmployeeID, Employees.EmpName, 
      Department.DepartmentName
FROM Employees INNER JOIN
      Department ON 
      Employees.DepartmentId = Department.DepartmentId
WHERE (Employees.EmpStatus = 1)">
</InfoLight:WebDataSource>
<InfoLight:WebDefault ID="wdServices_SV_StatEmp" runat="server" DataMember="Services_SV_StatEmp" DataSourceID="Master">
   <Fields>
      <InfoLight:DefaultFieldItem FieldName="Id" DefaultValue="0" />
   </Fields>
</InfoLight:WebDefault>
<InfoLight:WebNavigator ID="WebNavigator1" runat="server" BindingObject="wgvMaster"
            Width="100%" StatusStrip="WebStatusStrip1" 
        CssClass="NavigatorBar" CtlHeight="25">
            <NavControls>
                <InfoLight:ControlItem ControlName="Add" ControlText="穝糤" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/add_C.gif" MouseOverImageUrl="../image/uipics/add2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/add3_C.gif" />
                <InfoLight:ControlItem ControlName="Apply" ControlText="郎" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/apply_C.gif" MouseOverImageUrl="../image/uipics/apply2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/apply3_C.gif" />
                <InfoLight:ControlItem ControlName="Abort" ControlText="斌" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/abort_C.gif" MouseOverImageUrl="../image/uipics/abort2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/abort3_C.gif" />
                <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/query_C.gif" MouseOverImageUrl="../image/uipics/query2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/query3_C.gif" />
                <InfoLight:ControlItem ControlName="Export" ControlType="Image" ControlVisible="True"
                    DisenableImageUrl="../Image/UIPics/Export3_C.gif" ImageUrl="../Image/UIPics/Export_C.gif"
                    MouseOverImageUrl="../Image/UIPics/Export2_C.gif" Size="48" />
            </NavControls>
            <NavStates>
                <InfoLight:WebNavigatorStateItem StateText="Initial" />
                <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                <InfoLight:WebNavigatorStateItem StateText="Editing" />
                <InfoLight:WebNavigatorStateItem StateText="Applying" />
                <InfoLight:WebNavigatorStateItem StateText="Changing" />
                <InfoLight:WebNavigatorStateItem StateText="Querying" />
                <InfoLight:WebNavigatorStateItem StateText="Printing" />
            </NavStates>
        </InfoLight:WebNavigator>
        
         <InfoLight:webgridview id="wgvMaster" runat="server"
            cellpadding="5" datasourceid="Master" forecolor="#333333" width="100%" 
        AbortIconUrl="../Image/UIPics/Abort.gif" AddIconUrl="../Image/UIPics/Add.gif" 
        ApplyIconUrl="../Image/UIPics/Apply.gif" 
        CancelIconUrl="../Image/UIPics/Cancel.gif" 
        MouseOverAbortIconUrl="../Image/UIPics/Abort2.gif" 
        MouseOverAddIconUrl="../Image/UIPics/Add2.gif" 
        MouseOverApplyIconUrl="../Image/UIPics/Apply2.gif" 
        MouseOverCancelIconUrl="../Image/UIPics/Cancel2.gif" 
        MouseOverOKIconUrl="../Image/UIPics/OK2.gif" 
        MouseOverQueryIconUrl="../Image/UIPics/Query2.gif" 
        OKIconUrl="../Image/UIPics/OK.gif" QueryIconUrl="../Image/UIPics/Query.gif" 
        HeaderStyleWrap="False" BackColor="White" BorderColor="White" 
        BorderStyle="Groove" BorderWidth="2px" DataMember="SV_StatEmp" 
        PageSize="15">
            <PagerSettings Mode="NumericFirstLast" />
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></FooterStyle>
            <navcontrols>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif" ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif" ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif" ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif"></InfoLight:ControlItem>
</navcontrols>
            <Columns>
                <asp:TemplateField>
                    <edititemtemplate>
<asp:ImageButton id="ImageButton1" runat="server" CommandName="Update" Text="Update" __designer:wfdid="w14" ImageUrl="~/Image/UIPics/OK.gif" CausesValidation="True"></asp:ImageButton><asp:ImageButton id="ImageButton2" runat="server" CommandName="Cancel" Text="Cancel" __designer:wfdid="w15" ImageUrl="~/Image/UIPics/Cancel.gif" CausesValidation="False"></asp:ImageButton>
</edititemtemplate>
                    <itemtemplate>
<asp:ImageButton id="ImageButton3" runat="server" CommandName="Edit" Text="Edit" __designer:wfdid="w12" ImageUrl="~/Image/UIPics/Edit.gif" CausesValidation="False"></asp:ImageButton><asp:ImageButton id="ImageButton4" runat="server" CommandName="Delete" Text="Delete" __designer:wfdid="w13" ImageUrl="~/Image/UIPics/Delete.gif" CausesValidation="False"></asp:ImageButton>
</itemtemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="Id" HeaderText="编号" SortExpression="Id" />
                <asp:TemplateField HeaderText="员工工号" SortExpression="EmployeeId">
                    <edititemtemplate>
<InfoLight:WebRefVal id="wrvServices_SV_StatEmpEmployeeIdE" runat="server" Width="130px" DataSourceID="wdsServices_SV_StatEmpEmployeeId" DataTextField="EmpName" AllowAddData="False" PostBackButonClick="False" UseButtonImage="True" BindingValue='<%# Bind("EmployeeId") %>' ResxDataSet UpdatePanelID DataValueField="EmployeeID" ButtonImageUrl="../Image/refval/RefVal.gif" BindingText ResxFilePath MultiLanguage="False" DataBindingField="EmployeeId" ReadOnly="False" __designer:wfdid="w19"><Columns>
<InfoLight:WebRefColumn ColumnName="DepartmentName" HeadText="所在部门" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="EmployeeID" HeadText="员工编号" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="EmpName" HeadText="员工姓名" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal>
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebRefVal id="wrvServices_SV_StatEmpEmployeeIdF" runat="server" Width="130px" DataSourceID="wdsServices_SV_StatEmpEmployeeId" DataTextField="EmpName" AllowAddData="False" PostBackButonClick="False" UseButtonImage="True" BindingValue='<%# Bind("EmployeeId") %>' ResxDataSet="" UpdatePanelID="" DataValueField="EmployeeID" ButtonImageUrl="../Image/refval/RefVal.gif" BindingText="" ResxFilePath="" MultiLanguage="False" DataBindingField="EmployeeId" ReadOnly="False" __designer:wfdid="w23"><Columns>
<InfoLight:WebRefColumn HeadText="所在部门" ColumnName="DepartmentName" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工编号" ColumnName="EmployeeID" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工姓名" ColumnName="EmpName" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal>
</footertemplate>
                    <itemtemplate>
<InfoLight:WebRefVal id="wrvServices_SV_StatEmpEmployeeId" runat="server" Width="130px" BorderStyle="None" BackColor="Transparent" DataSourceID="wdsServices_SV_StatEmpEmployeeId" DataTextField="EmpName" AllowAddData="False" PostBackButonClick="False" UseButtonImage="True" BindingValue='<%# Bind("EmployeeId") %>' ResxDataSet="" UpdatePanelID="" DataValueField="EmployeeID" ButtonImageUrl="../Image/refval/RefVal.gif" BindingText="" ResxFilePath="" MultiLanguage="False" DataBindingField="EmployeeId" ReadOnly="True" __designer:wfdid="w21"><Columns>
<InfoLight:WebRefColumn HeadText="所在部门" ColumnName="DepartmentName" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工编号" ColumnName="EmployeeID" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工姓名" ColumnName="EmpName" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal>
</itemtemplate>
                </asp:TemplateField>
</Columns>

<RowStyle BackColor="#EFF3FB"></RowStyle>

<EditRowStyle BackColor="#2461BF"></EditRowStyle>

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"></SelectedRowStyle>

<PagerStyle BackColor="LightBlue" ForeColor="White" HorizontalAlign="Center"></PagerStyle>

<HeaderStyle BackColor="DeepSkyBlue" ForeColor="White" Font-Bold="True"></HeaderStyle>

<AlternatingRowStyle BackColor="White" BorderColor="White"></AlternatingRowStyle>
            <AddNewRowControls>
                <InfoLight:AddNewRowControlItem ControlID="wrvServices_SV_StatEmpEmployeeIdF" ControlType="RefVal"
                    FieldName="EmployeeId" />
            </AddNewRowControls>
</InfoLight:webgridview>
</asp:Content>

